using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity.ModelConfiguration;

namespace ConsoleApplication2.Models.Mapping
{
    public class SyMap : EntityTypeConfiguration<Sy>
    {
        public SyMap()
        {
            // Primary Key
            this.HasKey(t => t.COMPANY);

            // Properties
            this.Property(t => t.CSHACCT)
                .HasMaxLength(40);

            this.Property(t => t.LOSSACCT)
                .HasMaxLength(40);

            this.Property(t => t.REACCT)
                .HasMaxLength(40);

            this.Property(t => t.ARACCT)
                .HasMaxLength(40);

            this.Property(t => t.APACCT)
                .HasMaxLength(40);

            this.Property(t => t.LATEACCT)
                .HasMaxLength(40);

            this.Property(t => t.FEDTXACCT)
                .HasMaxLength(40);

            this.Property(t => t.SLSTXACCT)
                .HasMaxLength(40);

            this.Property(t => t.RPTPDSTART)
                .HasMaxLength(4);

            this.Property(t => t.RPTPDEND)
                .HasMaxLength(4);

            this.Property(t => t.COMPANY)
                .IsRequired()
                .HasMaxLength(55);

            this.Property(t => t.ADDRESS1)
                .HasMaxLength(33);

            this.Property(t => t.ADDRESS2)
                .HasMaxLength(33);

            this.Property(t => t.CITY)
                .HasMaxLength(24);

            this.Property(t => t.STATE)
                .HasMaxLength(3);

            this.Property(t => t.ZIP)
                .HasMaxLength(14);

            this.Property(t => t.PHONE)
                .HasMaxLength(12);

            this.Property(t => t.FAX)
                .HasMaxLength(12);

            this.Property(t => t.FEDID)
                .HasMaxLength(10);

            this.Property(t => t.DFLTPORT)
                .HasMaxLength(4);

            this.Property(t => t.QTYPIC)
                .HasMaxLength(9);

            this.Property(t => t.PRCPIC)
                .HasMaxLength(9);

            this.Property(t => t.ARDISCACCT)
                .HasMaxLength(40);

            this.Property(t => t.BANKNAME)
                .HasMaxLength(30);

            this.Property(t => t.BANKBRANCH)
                .HasMaxLength(30);

            this.Property(t => t.BANKADDR)
                .HasMaxLength(30);

            this.Property(t => t.BANKCODE)
                .HasMaxLength(25);

            this.Property(t => t.BANKENCD)
                .HasMaxLength(56);

            this.Property(t => t.GLPERIOD)
                .HasMaxLength(4);

            this.Property(t => t.APPERIOD)
                .HasMaxLength(4);

            this.Property(t => t.ARPERIOD)
                .HasMaxLength(4);

            this.Property(t => t.INVSRKACCT)
                .HasMaxLength(40);

            this.Property(t => t.FEDID_PR)
                .HasMaxLength(11);

            this.Property(t => t.STATEID)
                .HasMaxLength(11);

            this.Property(t => t.LIABACCT)
                .HasMaxLength(40);

            this.Property(t => t.SUTAACCT)
                .HasMaxLength(40);

            this.Property(t => t.FUTAACCT)
                .HasMaxLength(40);

            this.Property(t => t.MEDIACCT)
                .HasMaxLength(40);

            this.Property(t => t.FICAACCT)
                .HasMaxLength(40);

            this.Property(t => t.ARAGINGPD)
                .HasMaxLength(4);

            this.Property(t => t.APAGINGPD)
                .HasMaxLength(4);

            this.Property(t => t.LOCS)
                .HasMaxLength(40);

            this.Property(t => t.EDITMASK)
                .HasMaxLength(45);

            this.Property(t => t.CSTCTRMASK)
                .HasMaxLength(15);

            this.Property(t => t.ENTMASK)
                .HasMaxLength(10);

            this.Property(t => t.MASKCHAR)
                .HasMaxLength(1);

            this.Property(t => t.DATASET)
                .HasMaxLength(20);

            this.Property(t => t.WORDPROC)
                .HasMaxLength(70);

            this.Property(t => t.MGROVRRIDE)
                .HasMaxLength(10);

            this.Property(t => t.INVMESSAGE)
                .HasMaxLength(254);

            this.Property(t => t.STORENUM)
                .HasMaxLength(5);

            this.Property(t => t.DATEFORMAT)
                .HasMaxLength(10);

            this.Property(t => t.PRBANK)
                .HasMaxLength(2);

            this.Property(t => t.APBANK)
                .HasMaxLength(2);

            this.Property(t => t.RETURNACCT)
                .HasMaxLength(40);

            this.Property(t => t.RETURNSALEACCT)
                .HasMaxLength(40);

            this.Property(t => t.DOECRB1ACT)
                .HasMaxLength(40);

            this.Property(t => t.DOECRB2ACT)
                .HasMaxLength(40);

            this.Property(t => t.DOEDRB1ACT)
                .HasMaxLength(40);

            this.Property(t => t.DOEDRB2ACT)
                .HasMaxLength(40);

            this.Property(t => t.SYMBB1)
                .IsFixedLength()
                .HasMaxLength(10);

            this.Property(t => t.SYMBB2)
                .IsFixedLength()
                .HasMaxLength(10);

            this.Property(t => t.PATACCT)
                .HasMaxLength(40);

            this.Property(t => t.DATAVERSION)
                .IsFixedLength()
                .HasMaxLength(20);

            this.Property(t => t.ENDINVACCT)
                .HasMaxLength(40);

            this.Property(t => t.CompanyLogo)
                .HasMaxLength(20);

            this.Property(t => t.PSDEFCASHACCT)
                .HasMaxLength(40);

            this.Property(t => t.HOSPCLASS)
                .HasMaxLength(10);

            this.Property(t => t.File_Primary_Key)
                .HasMaxLength(10);

            this.Property(t => t.CustArPrefixAcct)
                .HasMaxLength(40);

            this.Property(t => t.VAT_REG_NUM)
                .HasMaxLength(30);

            this.Property(t => t.IN_VAT_ACCT)
                .HasMaxLength(40);

            this.Property(t => t.OUT_VAT_ACCT)
                .HasMaxLength(40);

            this.Property(t => t.CASHVATACCT)
                .HasMaxLength(40);

            this.Property(t => t.OnStart_Script_Path)
                .HasMaxLength(100);

            this.Property(t => t.Case_Number)
                .HasMaxLength(15);

            this.Property(t => t.BillingCashacct)
                .HasMaxLength(40);

            this.Property(t => t.Billnumber)
                .HasMaxLength(8);

            this.Property(t => t.Default_physician_fees)
                .HasMaxLength(40);

            this.Property(t => t.TicketRevAcct)
                .HasMaxLength(40);

            this.Property(t => t.custdefacct)
                .HasMaxLength(40);

            this.Property(t => t.Cashdefacct)
                .HasMaxLength(40);

            this.Property(t => t.TicketExpAcct)
                .HasMaxLength(40);

            this.Property(t => t.BSPNUMBER)
                .HasMaxLength(3);

            this.Property(t => t.Memovoucher)
                .HasMaxLength(8);

            this.Property(t => t.case_numberforoutpat)
                .HasMaxLength(15);

            this.Property(t => t.Revenue_Account)
                .HasMaxLength(40);

            this.Property(t => t.Cost_of_Good_Account)
                .HasMaxLength(40);

            this.Property(t => t.Inventory_Account)
                .HasMaxLength(40);

            this.Property(t => t.Def_undercollacct_fordoctors)
                .HasMaxLength(40);

            this.Property(t => t.oe_discountacct)
                .HasMaxLength(40);

            this.Property(t => t.RejectedClaimacct_DB)
                .HasMaxLength(40);

            this.Property(t => t.RejectedClaimacct_CR)
                .HasMaxLength(40);

            this.Property(t => t.MulticurrencyMask)
                .HasMaxLength(200);

            this.Property(t => t.InternalMask)
                .HasMaxLength(200);

            this.Property(t => t.NSSF)
                .HasMaxLength(6);

            this.Property(t => t.cashreturnacct)
                .HasMaxLength(40);

            this.Property(t => t.DatabaseVersion)
                .HasMaxLength(200);

            this.Property(t => t.CustomerReportCode)
                .HasMaxLength(20);

            this.Property(t => t.ShipCity)
                .HasMaxLength(100);

            this.Property(t => t.ShipAddr1)
                .HasMaxLength(100);

            this.Property(t => t.ShipAddr2)
                .HasMaxLength(100);

            this.Property(t => t.ShipPhone)
                .HasMaxLength(30);

            this.Property(t => t.ShipFax)
                .HasMaxLength(30);

            this.Property(t => t.CCCashAccount)
                .HasMaxLength(40);

            this.Property(t => t.DFAdjAccount)
                .HasMaxLength(40);

            this.Property(t => t.dc_ImageEditor)
                .HasMaxLength(255);

            this.Property(t => t.AutoTransferLoc)
                .IsFixedLength()
                .HasMaxLength(10);

            this.Property(t => t.Acompany)
                .HasMaxLength(100);

            this.Property(t => t.A_Address1)
                .HasMaxLength(50);

            this.Property(t => t.A_Address2)
                .HasMaxLength(50);

            this.Property(t => t.ACity)
                .HasMaxLength(50);

            this.Property(t => t.PhysFeesAcct)
                .HasMaxLength(40);

            this.Property(t => t.PaymentDiscountAcct)
                .HasMaxLength(40);

            this.Property(t => t.GuarDiscAcct)
                .HasMaxLength(40);

            this.Property(t => t.Integration)
                .HasMaxLength(50);

            this.Property(t => t.ACP_Path)
                .HasMaxLength(200);

            this.Property(t => t.ACP_PatchFile)
                .HasMaxLength(200);

            this.Property(t => t.SM_CUSTID_IncType)
                .HasMaxLength(1);

            this.Property(t => t.SM_NewDocRef_Mode)
                .HasMaxLength(30);

            this.Property(t => t.Per_ReDrawMode)
                .HasMaxLength(20);

            this.Property(t => t.Per_DefSeq)
                .HasMaxLength(20);

            this.Property(t => t.SYS_DefPhysAcct)
                .HasMaxLength(40);

            this.Property(t => t.SYS_SM_PR_ReferencePrefix)
                .HasMaxLength(5);

            this.Property(t => t.sys_Nssf_)
                .HasMaxLength(20);

            this.Property(t => t.SYS_ADM_I_PREFIX)
                .HasMaxLength(20);

            this.Property(t => t.SYS_ADM_O_PREFIX)
                .HasMaxLength(20);

            this.Property(t => t.SYS_ADM_E_PREFIX)
                .HasMaxLength(20);

            this.Property(t => t.sys_InCaseNumPrefix)
                .HasMaxLength(3);

            this.Property(t => t.sys_OutCaseNumPrefix)
                .HasMaxLength(3);

            // Table & Column Mappings
            this.ToTable("Sys");
            this.Property(t => t.CSHACCT).HasColumnName("CSHACCT");
            this.Property(t => t.LOSSACCT).HasColumnName("LOSSACCT");
            this.Property(t => t.REACCT).HasColumnName("REACCT");
            this.Property(t => t.ARACCT).HasColumnName("ARACCT");
            this.Property(t => t.APACCT).HasColumnName("APACCT");
            this.Property(t => t.LATEACCT).HasColumnName("LATEACCT");
            this.Property(t => t.FEDTXACCT).HasColumnName("FEDTXACCT");
            this.Property(t => t.SLSTXACCT).HasColumnName("SLSTXACCT");
            this.Property(t => t.RPTPDSTART).HasColumnName("RPTPDSTART");
            this.Property(t => t.RPTPDEND).HasColumnName("RPTPDEND");
            this.Property(t => t.COMPANY).HasColumnName("COMPANY");
            this.Property(t => t.ADDRESS1).HasColumnName("ADDRESS1");
            this.Property(t => t.ADDRESS2).HasColumnName("ADDRESS2");
            this.Property(t => t.CITY).HasColumnName("CITY");
            this.Property(t => t.STATE).HasColumnName("STATE");
            this.Property(t => t.ZIP).HasColumnName("ZIP");
            this.Property(t => t.PHONE).HasColumnName("PHONE");
            this.Property(t => t.FAX).HasColumnName("FAX");
            this.Property(t => t.FEDID).HasColumnName("FEDID");
            this.Property(t => t.DFLTPORT).HasColumnName("DFLTPORT");
            this.Property(t => t.REFERENCE).HasColumnName("REFERENCE");
            this.Property(t => t.NEXTBATCH).HasColumnName("NEXTBATCH");
            this.Property(t => t.VENDOR).HasColumnName("VENDOR");
            this.Property(t => t.CUSTOMER).HasColumnName("CUSTOMER");
            this.Property(t => t.ITEM).HasColumnName("ITEM");
            this.Property(t => t.MULTIACCT).HasColumnName("MULTIACCT");
            this.Property(t => t.APMEMOPRN).HasColumnName("APMEMOPRN");
            this.Property(t => t.ARMEMOPRN).HasColumnName("ARMEMOPRN");
            this.Property(t => t.GL).HasColumnName("GL");
            this.Property(t => t.REINIT).HasColumnName("REINIT");
            this.Property(t => t.GLSUPPRESS).HasColumnName("GLSUPPRESS");
            this.Property(t => t.ROLLUPCHKS).HasColumnName("ROLLUPCHKS");
            this.Property(t => t.CHKSPRNTED).HasColumnName("CHKSPRNTED");
            this.Property(t => t.CHKJOURNAL).HasColumnName("CHKJOURNAL");
            this.Property(t => t.ARLATEFEE).HasColumnName("ARLATEFEE");
            this.Property(t => t.ARCUTOFF).HasColumnName("ARCUTOFF");
            this.Property(t => t.LATEFEEMIN).HasColumnName("LATEFEEMIN");
            this.Property(t => t.OEQUOTE).HasColumnName("OEQUOTE");
            this.Property(t => t.OEORDER).HasColumnName("OEORDER");
            this.Property(t => t.OEINVOICE).HasColumnName("OEINVOICE");
            this.Property(t => t.OEBKORDER).HasColumnName("OEBKORDER");
            this.Property(t => t.OECLOSEINV).HasColumnName("OECLOSEINV");
            this.Property(t => t.IPRECEIPT).HasColumnName("IPRECEIPT");
            this.Property(t => t.IPPURCHORD).HasColumnName("IPPURCHORD");
            this.Property(t => t.FEDTAX).HasColumnName("FEDTAX");
            this.Property(t => t.QTYDEC).HasColumnName("QTYDEC");
            this.Property(t => t.PRCDEC).HasColumnName("PRCDEC");
            this.Property(t => t.QTYPIC).HasColumnName("QTYPIC");
            this.Property(t => t.PRCPIC).HasColumnName("PRCPIC");
            this.Property(t => t.INVJOURNAL).HasColumnName("INVJOURNAL");
            this.Property(t => t.CANADA).HasColumnName("CANADA");
            this.Property(t => t.BACKORDER).HasColumnName("BACKORDER");
            this.Property(t => t.ARDISCACCT).HasColumnName("ARDISCACCT");
            this.Property(t => t.LASERCKS).HasColumnName("LASERCKS");
            this.Property(t => t.BANKNAME).HasColumnName("BANKNAME");
            this.Property(t => t.BANKBRANCH).HasColumnName("BANKBRANCH");
            this.Property(t => t.BANKADDR).HasColumnName("BANKADDR");
            this.Property(t => t.BANKCODE).HasColumnName("BANKCODE");
            this.Property(t => t.BANKENCD).HasColumnName("BANKENCD");
            this.Property(t => t.CHECKNO).HasColumnName("CHECKNO");
            this.Property(t => t.GLPERIOD).HasColumnName("GLPERIOD");
            this.Property(t => t.APPERIOD).HasColumnName("APPERIOD");
            this.Property(t => t.ARPERIOD).HasColumnName("ARPERIOD");
            this.Property(t => t.EXTNDDESC).HasColumnName("EXTNDDESC");
            this.Property(t => t.ASSET).HasColumnName("ASSET");
            this.Property(t => t.ACCTPDS).HasColumnName("ACCTPDS");
            this.Property(t => t.INVSRKACCT).HasColumnName("INVSRKACCT");
            this.Property(t => t.FEDID_PR).HasColumnName("FEDID_PR");
            this.Property(t => t.STATEID).HasColumnName("STATEID");
            this.Property(t => t.SSWGLMT).HasColumnName("SSWGLMT");
            this.Property(t => t.SSRATE).HasColumnName("SSRATE");
            this.Property(t => t.MEDIWGLMT).HasColumnName("MEDIWGLMT");
            this.Property(t => t.MEDIRATE).HasColumnName("MEDIRATE");
            this.Property(t => t.FUTAWGLMT).HasColumnName("FUTAWGLMT");
            this.Property(t => t.FUTARATE).HasColumnName("FUTARATE");
            this.Property(t => t.SUTAWGLMT).HasColumnName("SUTAWGLMT");
            this.Property(t => t.SUTARATE).HasColumnName("SUTARATE");
            this.Property(t => t.CKDATE).HasColumnName("CKDATE");
            this.Property(t => t.PDSTART).HasColumnName("PDSTART");
            this.Property(t => t.PDEND).HasColumnName("PDEND");
            this.Property(t => t.PRCKSPRNTD).HasColumnName("PRCKSPRNTD");
            this.Property(t => t.PRJRNPRNTD).HasColumnName("PRJRNPRNTD");
            this.Property(t => t.TMSPRNTD).HasColumnName("TMSPRNTD");
            this.Property(t => t.CKREGPRNTD).HasColumnName("CKREGPRNTD");
            this.Property(t => t.LIABACCT).HasColumnName("LIABACCT");
            this.Property(t => t.SUTAACCT).HasColumnName("SUTAACCT");
            this.Property(t => t.FUTAACCT).HasColumnName("FUTAACCT");
            this.Property(t => t.MEDIACCT).HasColumnName("MEDIACCT");
            this.Property(t => t.FICAACCT).HasColumnName("FICAACCT");
            this.Property(t => t.REF_PR).HasColumnName("REF_PR");
            this.Property(t => t.ARAGINGPD).HasColumnName("ARAGINGPD");
            this.Property(t => t.APAGINGPD).HasColumnName("APAGINGPD");
            this.Property(t => t.LASERINV).HasColumnName("LASERINV");
            this.Property(t => t.MULTILOC).HasColumnName("MULTILOC");
            this.Property(t => t.NEXTKIT).HasColumnName("NEXTKIT");
            this.Property(t => t.FADEPCALC).HasColumnName("FADEPCALC");
            this.Property(t => t.FADEPJRNL).HasColumnName("FADEPJRNL");
            this.Property(t => t.BATCH).HasColumnName("BATCH");
            this.Property(t => t.LOCS).HasColumnName("LOCS");
            this.Property(t => t.LENGTH).HasColumnName("LENGTH");
            this.Property(t => t.EDITMASK).HasColumnName("EDITMASK");
            this.Property(t => t.CSTCTRMASK).HasColumnName("CSTCTRMASK");
            this.Property(t => t.ENTMASK).HasColumnName("ENTMASK");
            this.Property(t => t.ACCTPOS).HasColumnName("ACCTPOS");
            this.Property(t => t.ACCTLEN).HasColumnName("ACCTLEN");
            this.Property(t => t.CSTCTRPOS).HasColumnName("CSTCTRPOS");
            this.Property(t => t.CSTCTRLEN).HasColumnName("CSTCTRLEN");
            this.Property(t => t.ENTPOS).HasColumnName("ENTPOS");
            this.Property(t => t.ENTLEN).HasColumnName("ENTLEN");
            this.Property(t => t.MASKCHAR).HasColumnName("MASKCHAR");
            this.Property(t => t.ENTITY1ST).HasColumnName("ENTITY1ST");
            this.Property(t => t.DATASET).HasColumnName("DATASET");
            this.Property(t => t.WORDPROC).HasColumnName("WORDPROC");
            this.Property(t => t.MGROVRRIDE).HasColumnName("MGROVRRIDE");
            this.Property(t => t.CUSTFILE).HasColumnName("CUSTFILE");
            this.Property(t => t.INVMESSAGE).HasColumnName("INVMESSAGE");
            this.Property(t => t.PERMITVOID).HasColumnName("PERMITVOID");
            this.Property(t => t.STORENUM).HasColumnName("STORENUM");
            this.Property(t => t.INVVALUE).HasColumnName("INVVALUE");
            this.Property(t => t.DATEFORMAT).HasColumnName("DATEFORMAT");
            this.Property(t => t.ITEMALIGN).HasColumnName("ITEMALIGN");
            this.Property(t => t.VENDALIGN).HasColumnName("VENDALIGN");
            this.Property(t => t.CUSTALIGN).HasColumnName("CUSTALIGN");
            this.Property(t => t.PRBANK).HasColumnName("PRBANK");
            this.Property(t => t.APBANK).HasColumnName("APBANK");
            this.Property(t => t.QCOPIES).HasColumnName("QCOPIES");
            this.Property(t => t.OCOPIES).HasColumnName("OCOPIES");
            this.Property(t => t.ICOPIES).HasColumnName("ICOPIES");
            this.Property(t => t.K).HasColumnName("K");
            this.Property(t => t.ARE).HasColumnName("ARE");
            this.Property(t => t.OR).HasColumnName("OR");
            this.Property(t => t.DOC_AR).HasColumnName("DOC_AR");
            this.Property(t => t.DOC_AP).HasColumnName("DOC_AP");
            this.Property(t => t.JV_AR).HasColumnName("JV_AR");
            this.Property(t => t.JV_AP).HasColumnName("JV_AP");
            this.Property(t => t.DIRECTPOST).HasColumnName("DIRECTPOST");
            this.Property(t => t.USER_CNT).HasColumnName("USER_CNT");
            this.Property(t => t.OEDETTRANS).HasColumnName("OEDETTRANS");
            this.Property(t => t.OR_OF_K).HasColumnName("OR_OF_K");
            this.Property(t => t.PV).HasColumnName("PV");
            this.Property(t => t.RV).HasColumnName("RV");
            this.Property(t => t.ADMISIONID).HasColumnName("ADMISIONID");
            this.Property(t => t.ADMALIGN).HasColumnName("ADMALIGN");
            this.Property(t => t.IPENTRYNO).HasColumnName("IPENTRYNO");
            this.Property(t => t.ITMPLISTNO).HasColumnName("ITMPLISTNO");
            this.Property(t => t.RATESID).HasColumnName("RATESID");
            this.Property(t => t.REFUNDJRNL).HasColumnName("REFUNDJRNL");
            this.Property(t => t.RETURNACCT).HasColumnName("RETURNACCT");
            this.Property(t => t.RETURNSALEACCT).HasColumnName("RETURNSALEACCT");
            this.Property(t => t.RETINVOICE).HasColumnName("RETINVOICE");
            this.Property(t => t.PSID).HasColumnName("PSID");
            this.Property(t => t.RPTDECMNUM).HasColumnName("RPTDECMNUM");
            this.Property(t => t.SCRDECMNUM).HasColumnName("SCRDECMNUM");
            this.Property(t => t.DOECRB1ACT).HasColumnName("DOECRB1ACT");
            this.Property(t => t.DOECRB2ACT).HasColumnName("DOECRB2ACT");
            this.Property(t => t.DOEDRB1ACT).HasColumnName("DOEDRB1ACT");
            this.Property(t => t.DOEDRB2ACT).HasColumnName("DOEDRB2ACT");
            this.Property(t => t.SYMBB1).HasColumnName("SYMBB1");
            this.Property(t => t.SYMBB2).HasColumnName("SYMBB2");
            this.Property(t => t.PROJECT).HasColumnName("PROJECT");
            this.Property(t => t.USEINVACT).HasColumnName("USEINVACT");
            this.Property(t => t.AutoInuse).HasColumnName("AutoInuse");
            this.Property(t => t.PATACCT).HasColumnName("PATACCT");
            this.Property(t => t.DATAVERSION).HasColumnName("DATAVERSION");
            this.Property(t => t.ENDINVACCT).HasColumnName("ENDINVACCT");
            this.Property(t => t.CompanyLogo).HasColumnName("CompanyLogo");
            this.Property(t => t.BATCHINCTYPE).HasColumnName("BATCHINCTYPE");
            this.Property(t => t.PRICINGMODE).HasColumnName("PRICINGMODE");
            this.Property(t => t.ItemAutoInsert).HasColumnName("ItemAutoInsert");
            this.Property(t => t.IMPORTEXPORT).HasColumnName("IMPORTEXPORT");
            this.Property(t => t.BARCODEMODE).HasColumnName("BARCODEMODE");
            this.Property(t => t.PSDEFCASHACCT).HasColumnName("PSDEFCASHACCT");
            this.Property(t => t.PSRECEIPTCOUNT).HasColumnName("PSRECEIPTCOUNT");
            this.Property(t => t.PSINVOICECOUNT).HasColumnName("PSINVOICECOUNT");
            this.Property(t => t.HOSPCLASS).HasColumnName("HOSPCLASS");
            this.Property(t => t.RECEIPTDISCCOUNT).HasColumnName("RECEIPTDISCCOUNT");
            this.Property(t => t.ADJID).HasColumnName("ADJID");
            this.Property(t => t.TWOPHASESTRANSFER).HasColumnName("TWOPHASESTRANSFER");
            this.Property(t => t.File_Primary_Key).HasColumnName("File Primary Key");
            this.Property(t => t.Rep_SiteIndex).HasColumnName("Rep_SiteIndex");
            this.Property(t => t.ArAcctIncType).HasColumnName("ArAcctIncType");
            this.Property(t => t.CustArPrefixAcct).HasColumnName("CustArPrefixAcct");
            this.Property(t => t.ArAcctCurrency).HasColumnName("ArAcctCurrency");
            this.Property(t => t.SaleMode).HasColumnName("SaleMode");
            this.Property(t => t.deprdate).HasColumnName("deprdate");
            this.Property(t => t.ENABLE_VAT).HasColumnName("ENABLE_VAT");
            this.Property(t => t.VAT_REG_NUM).HasColumnName("VAT_REG_NUM");
            this.Property(t => t.VAT_RATE).HasColumnName("VAT_RATE");
            this.Property(t => t.ENABLE_IN_VAT).HasColumnName("ENABLE_IN_VAT");
            this.Property(t => t.ENABLE_OUT_VAT).HasColumnName("ENABLE_OUT_VAT");
            this.Property(t => t.IN_VAT_ACCT).HasColumnName("IN_VAT_ACCT");
            this.Property(t => t.OUT_VAT_ACCT).HasColumnName("OUT_VAT_ACCT");
            this.Property(t => t.use_cstctr).HasColumnName("use_cstctr");
            this.Property(t => t.CASHVATACCT).HasColumnName("CASHVATACCT");
            this.Property(t => t.DELIVERYNOTE).HasColumnName("DELIVERYNOTE");
            this.Property(t => t.Publisher_System_date).HasColumnName("Publisher_System_date");
            this.Property(t => t.ISIPWITHFA).HasColumnName("ISIPWITHFA");
            this.Property(t => t.AllowManPatId).HasColumnName("AllowManPatId");
            this.Property(t => t.DecimalVal).HasColumnName("DecimalVal");
            this.Property(t => t.SPIRBPG).HasColumnName("SPIRBPG");
            this.Property(t => t.OEDefCstCtr).HasColumnName("OEDefCstCtr");
            this.Property(t => t.IP_DynamicReorderingEnabled).HasColumnName("IP_DynamicReorderingEnabled");
            this.Property(t => t.EnableProduction).HasColumnName("EnableProduction");
            this.Property(t => t.EnableApArAcctPerCurrency).HasColumnName("EnableApArAcctPerCurrency");
            this.Property(t => t.DefaultBarcodeLabel).HasColumnName("DefaultBarcodeLabel");
            this.Property(t => t.DefaultItemFactor).HasColumnName("DefaultItemFactor");
            this.Property(t => t.EnableCustSegmentation).HasColumnName("EnableCustSegmentation");
            this.Property(t => t.PointSys).HasColumnName("PointSys");
            this.Property(t => t.PSPAYMENTID).HasColumnName("PSPAYMENTID");
            this.Property(t => t.EnableTCCMode).HasColumnName("EnableTCCMode");
            this.Property(t => t.AllowNegQTY).HasColumnName("AllowNegQTY");
            this.Property(t => t.SingleCustPerAcct).HasColumnName("SingleCustPerAcct");
            this.Property(t => t.OnStart_Script_Path).HasColumnName("OnStart_Script_Path");
            this.Property(t => t.Case_Number).HasColumnName("Case_Number");
            this.Property(t => t.BillingCashacct).HasColumnName("BillingCashacct");
            this.Property(t => t.Adddoctorauto).HasColumnName("Adddoctorauto");
            this.Property(t => t.Billnumber).HasColumnName("Billnumber");
            this.Property(t => t.Dental).HasColumnName("Dental");
            this.Property(t => t.Expiry).HasColumnName("Expiry");
            this.Property(t => t.Lastrefresh).HasColumnName("Lastrefresh");
            this.Property(t => t.Patientdiscmode).HasColumnName("Patientdiscmode");
            this.Property(t => t.DefaultNationality).HasColumnName("DefaultNationality");
            this.Property(t => t.Default_physician_fees).HasColumnName("Default_physician_fees");
            this.Property(t => t.enableclosing).HasColumnName("enableclosing");
            this.Property(t => t.Sellingrate).HasColumnName("Sellingrate");
            this.Property(t => t.TicketRevAcct).HasColumnName("TicketRevAcct");
            this.Property(t => t.custdefacct).HasColumnName("custdefacct");
            this.Property(t => t.Cashdefacct).HasColumnName("Cashdefacct");
            this.Property(t => t.TicketExpAcct).HasColumnName("TicketExpAcct");
            this.Property(t => t.BSPNUMBER).HasColumnName("BSPNUMBER");
            this.Property(t => t.Memovoucher).HasColumnName("Memovoucher");
            this.Property(t => t.XONUMBER).HasColumnName("XONUMBER");
            this.Property(t => t.Domyticketnb).HasColumnName("Domyticketnb");
            this.Property(t => t.enablepayment).HasColumnName("enablepayment");
            this.Property(t => t.Arabicsearch).HasColumnName("Arabicsearch");
            this.Property(t => t.case_numberforoutpat).HasColumnName("case_numberforoutpat");
            this.Property(t => t.physicianShareafterdiscount).HasColumnName("physicianShareafterdiscount");
            this.Property(t => t.Entrytypeoptional).HasColumnName("Entrytypeoptional");
            this.Property(t => t.assignopriceforchilditem).HasColumnName("assignopriceforchilditem");
            this.Property(t => t.Frsmode).HasColumnName("Frsmode");
            this.Property(t => t.itemavailableforeturn).HasColumnName("itemavailableforeturn");
            this.Property(t => t.Saudisystem).HasColumnName("Saudisystem");
            this.Property(t => t.DefaultBillPriceList).HasColumnName("DefaultBillPriceList");
            this.Property(t => t.enablephrate).HasColumnName("enablephrate");
            this.Property(t => t.costcenter_mode).HasColumnName("costcenter_mode");
            this.Property(t => t.Revenue_Account).HasColumnName("Revenue_Account");
            this.Property(t => t.Cost_of_Good_Account).HasColumnName("Cost_of_Good_Account");
            this.Property(t => t.Inventory_Account).HasColumnName("Inventory_Account");
            this.Property(t => t.Account_mode).HasColumnName("Account_mode");
            this.Property(t => t.Header_length).HasColumnName("Header_length");
            this.Property(t => t.subaccount_length).HasColumnName("subaccount_length");
            this.Property(t => t.Batch_mode).HasColumnName("Batch_mode");
            this.Property(t => t.voucherincash).HasColumnName("voucherincash");
            this.Property(t => t.voucherinonacct).HasColumnName("voucherinonacct");
            this.Property(t => t.voucheroutcash).HasColumnName("voucheroutcash");
            this.Property(t => t.voucheroutonacct).HasColumnName("voucheroutonacct");
            this.Property(t => t.voucherbatch).HasColumnName("voucherbatch");
            this.Property(t => t.Usedictionary).HasColumnName("Usedictionary");
            this.Property(t => t.ACCTPV).HasColumnName("ACCTPV");
            this.Property(t => t.ACCTRV).HasColumnName("ACCTRV");
            this.Property(t => t.use_physicianfees_under_collectionacct).HasColumnName("use_physicianfees_under_collectionacct");
            this.Property(t => t.Def_undercollacct_fordoctors).HasColumnName("Def_undercollacct_fordoctors");
            this.Property(t => t.oe_discountacct).HasColumnName("oe_discountacct");
            this.Property(t => t.RejectedClaimacct_DB).HasColumnName("RejectedClaimacct_DB");
            this.Property(t => t.RejectedClaimacct_CR).HasColumnName("RejectedClaimacct_CR");
            this.Property(t => t.Def_paymentdistributemode).HasColumnName("Def_paymentdistributemode");
            this.Property(t => t.putdiscountforpatientdueonly).HasColumnName("putdiscountforpatientdueonly");
            this.Property(t => t.MulticurrencyMask).HasColumnName("MulticurrencyMask");
            this.Property(t => t.InternalMask).HasColumnName("InternalMask");
            this.Property(t => t.Transid).HasColumnName("Transid");
            this.Property(t => t.TreatmentPlanID).HasColumnName("TreatmentPlanID");
            this.Property(t => t.NumericCaseNb).HasColumnName("NumericCaseNb");
            this.Property(t => t.NSSF).HasColumnName("NSSF");
            this.Property(t => t.PatientAllFieldsRequired).HasColumnName("PatientAllFieldsRequired");
            this.Property(t => t.UseGuarantorDiscountAccounts).HasColumnName("UseGuarantorDiscountAccounts");
            this.Property(t => t.language).HasColumnName("language");
            this.Property(t => t.RepairJobID).HasColumnName("RepairJobID");
            this.Property(t => t.cashreturnacct).HasColumnName("cashreturnacct");
            this.Property(t => t.acct_revenue_cost_inventory_mode).HasColumnName("acct_revenue_cost_inventory_mode");
            this.Property(t => t.acct_vat_mode).HasColumnName("acct_vat_mode");
            this.Property(t => t.acct_return_mode).HasColumnName("acct_return_mode");
            this.Property(t => t.CustomerIID).HasColumnName("CustomerIID");
            this.Property(t => t.VendorIID).HasColumnName("VendorIID");
            this.Property(t => t.SbatchNb).HasColumnName("SbatchNb");
            this.Property(t => t.PostingStartDate).HasColumnName("PostingStartDate");
            this.Property(t => t.LastBackup).HasColumnName("LastBackup");
            this.Property(t => t.DatabaseVersion).HasColumnName("DatabaseVersion");
            this.Property(t => t.sc_ShortNames).HasColumnName("sc_ShortNames");
            this.Property(t => t.CustomerReportCode).HasColumnName("CustomerReportCode");
            this.Property(t => t.ShowReportformats).HasColumnName("ShowReportformats");
            this.Property(t => t.DefaultType).HasColumnName("DefaultType");
            this.Property(t => t.BillTab).HasColumnName("BillTab");
            this.Property(t => t.ScTableLikeUser).HasColumnName("ScTableLikeUser");
            this.Property(t => t.Logo).HasColumnName("Logo");
            this.Property(t => t.frm_columns).HasColumnName("frm_columns");
            this.Property(t => t.frm_showhint).HasColumnName("frm_showhint");
            this.Property(t => t.frm_PageToolbarOrient).HasColumnName("frm_PageToolbarOrient");
            this.Property(t => t.frm_Width).HasColumnName("frm_Width");
            this.Property(t => t.frm_height).HasColumnName("frm_height");
            this.Property(t => t.frm_page_id).HasColumnName("frm_page_id");
            this.Property(t => t.frm_section_id).HasColumnName("frm_section_id");
            this.Property(t => t.UnProtectAccounts).HasColumnName("UnProtectAccounts");
            this.Property(t => t.PostingStart).HasColumnName("PostingStart");
            this.Property(t => t.HidebillStaff).HasColumnName("HidebillStaff");
            this.Property(t => t.PhysFeesItemID).HasColumnName("PhysFeesItemID");
            this.Property(t => t.PhysFeesTypeID).HasColumnName("PhysFeesTypeID");
            this.Property(t => t.PhysFeesCatID).HasColumnName("PhysFeesCatID");
            this.Property(t => t.PhysFeesPlanID).HasColumnName("PhysFeesPlanID");
            this.Property(t => t.ShipCity).HasColumnName("ShipCity");
            this.Property(t => t.ShipAddr1).HasColumnName("ShipAddr1");
            this.Property(t => t.ShipAddr2).HasColumnName("ShipAddr2");
            this.Property(t => t.ShipPhone).HasColumnName("ShipPhone");
            this.Property(t => t.ShipFax).HasColumnName("ShipFax");
            this.Property(t => t.SecondOperPerc_K).HasColumnName("SecondOperPerc_K");
            this.Property(t => t.SecondOperPerc_ARE).HasColumnName("SecondOperPerc_ARE");
            this.Property(t => t.SecondOperPerc_OR).HasColumnName("SecondOperPerc_OR");
            this.Property(t => t.InitFob_fob_Up).HasColumnName("InitFob_fob_Up");
            this.Property(t => t.fob_Landed_Up).HasColumnName("fob_Landed_Up");
            this.Property(t => t.PostingEndDate).HasColumnName("PostingEndDate");
            this.Property(t => t.AutoPostPay).HasColumnName("AutoPostPay");
            this.Property(t => t.CCCashAccount).HasColumnName("CCCashAccount");
            this.Property(t => t.DFAdjAccount).HasColumnName("DFAdjAccount");
            this.Property(t => t.Sc_DSearchField).HasColumnName("Sc_DSearchField");
            this.Property(t => t.ShowEyeForms).HasColumnName("ShowEyeForms");
            this.Property(t => t.Trt_order).HasColumnName("Trt_order");
            this.Property(t => t.Dc_NBsystem).HasColumnName("Dc_NBsystem");
            this.Property(t => t.DC_ShowGingiva).HasColumnName("DC_ShowGingiva");
            this.Property(t => t.DC_HistoryLightness).HasColumnName("DC_HistoryLightness");
            this.Property(t => t.DC_MouseSettings).HasColumnName("DC_MouseSettings");
            this.Property(t => t.DC_ProceduresSelection).HasColumnName("DC_ProceduresSelection");
            this.Property(t => t.DC_ProceduresDeletion).HasColumnName("DC_ProceduresDeletion");
            this.Property(t => t.DC_ChartBackColor).HasColumnName("DC_ChartBackColor");
            this.Property(t => t.DC_version).HasColumnName("DC_version");
            this.Property(t => t.hideFinTrtCard).HasColumnName("hideFinTrtCard");
            this.Property(t => t.chartid).HasColumnName("chartid");
            this.Property(t => t.dc_ImageEditor).HasColumnName("dc_ImageEditor");
            this.Property(t => t.Dc_ProcedureGID).HasColumnName("Dc_ProcedureGID");
            this.Property(t => t.dc_AdultAge).HasColumnName("dc_AdultAge");
            this.Property(t => t.AdjHeader).HasColumnName("AdjHeader");
            this.Property(t => t.AutoTransferLoc).HasColumnName("AutoTransferLoc");
            this.Property(t => t.InvertQtyInAdj).HasColumnName("InvertQtyInAdj");
            this.Property(t => t.lab_adultAge).HasColumnName("lab_adultAge");
            this.Property(t => t.Acompany).HasColumnName("Acompany");
            this.Property(t => t.A_Address1).HasColumnName("A_Address1");
            this.Property(t => t.A_Address2).HasColumnName("A_Address2");
            this.Property(t => t.ACity).HasColumnName("ACity");
            this.Property(t => t.PhysFeesAcct).HasColumnName("PhysFeesAcct");
            this.Property(t => t.PostGrossRev).HasColumnName("PostGrossRev");
            this.Property(t => t.multicurrency).HasColumnName("multicurrency");
            this.Property(t => t.Grid_TitleSize).HasColumnName("Grid_TitleSize");
            this.Property(t => t.Grid_FontSize).HasColumnName("Grid_FontSize");
            this.Property(t => t.Grid_RowHeightPerc).HasColumnName("Grid_RowHeightPerc");
            this.Property(t => t.Grid_TitleHeight).HasColumnName("Grid_TitleHeight");
            this.Property(t => t.CopyPatientNames).HasColumnName("CopyPatientNames");
            this.Property(t => t.DepartmentDiscount).HasColumnName("DepartmentDiscount");
            this.Property(t => t.PaymentDiscountAcct).HasColumnName("PaymentDiscountAcct");
            this.Property(t => t.PrescriptionVersion).HasColumnName("PrescriptionVersion");
            this.Property(t => t.OutPresID).HasColumnName("OutPresID");
            this.Property(t => t.frm_FontSize).HasColumnName("frm_FontSize");
            this.Property(t => t.frm_HLineSpacing).HasColumnName("frm_HLineSpacing");
            this.Property(t => t.frm_VLineSpacing).HasColumnName("frm_VLineSpacing");
            this.Property(t => t.BatchNumberingStartDate).HasColumnName("BatchNumberingStartDate");
            this.Property(t => t.OE_NO_RefreshTime).HasColumnName("OE_NO_RefreshTime");
            this.Property(t => t.OE_NO_BeepEnabled).HasColumnName("OE_NO_BeepEnabled");
            this.Property(t => t.OE_nO_BeepCount).HasColumnName("OE_nO_BeepCount");
            this.Property(t => t.OE_RO_RefreshTime).HasColumnName("OE_RO_RefreshTime");
            this.Property(t => t.OE_RO_BeepEnabled).HasColumnName("OE_RO_BeepEnabled");
            this.Property(t => t.OE_RO_BeepCount).HasColumnName("OE_RO_BeepCount");
            this.Property(t => t.DoNotImportTreatmentCard).HasColumnName("DoNotImportTreatmentCard");
            this.Property(t => t.LaboratoryChildAge).HasColumnName("LaboratoryChildAge");
            this.Property(t => t.GuarDiscAcct).HasColumnName("GuarDiscAcct");
            this.Property(t => t.OE_ImportPhy).HasColumnName("OE_ImportPhy");
            this.Property(t => t.DefCur).HasColumnName("DefCur");
            this.Property(t => t.AdjCheckOnhand).HasColumnName("AdjCheckOnhand");
            this.Property(t => t.AppCalFOntSize).HasColumnName("AppCalFOntSize");
            this.Property(t => t.Integration).HasColumnName("Integration");
            this.Property(t => t.SeperateACCTPVRV).HasColumnName("SeperateACCTPVRV");
            this.Property(t => t.Dental_Integration).HasColumnName("Dental_Integration");
            this.Property(t => t.Light_clinic).HasColumnName("Light_clinic");
            this.Property(t => t.ShowPatientToolbar).HasColumnName("ShowPatientToolbar");
            this.Property(t => t.AddReferraltoPhysFees).HasColumnName("AddReferraltoPhysFees");
            this.Property(t => t.PhysFeesAfterReferral).HasColumnName("PhysFeesAfterReferral");
            this.Property(t => t.PhysFeesAfterCost).HasColumnName("PhysFeesAfterCost");
            this.Property(t => t.TPI_Interface).HasColumnName("TPI_Interface");
            this.Property(t => t.TPI_Log).HasColumnName("TPI_Log");
            this.Property(t => t.IP_UpPharPrices).HasColumnName("IP_UpPharPrices");
            this.Property(t => t.BL_ReferenceStartDate).HasColumnName("BL_ReferenceStartDate");
            this.Property(t => t.BL_EnableReference).HasColumnName("BL_EnableReference");
            this.Property(t => t.Pha_ExcludeZeroPrice).HasColumnName("Pha_ExcludeZeroPrice");
            this.Property(t => t.SYS_BL_Reference).HasColumnName("SYS_BL_Reference");
            this.Property(t => t.SYS_PT_Number).HasColumnName("SYS_PT_Number");
            this.Property(t => t.SYS_GL_AuditPosting).HasColumnName("SYS_GL_AuditPosting");
            this.Property(t => t.SYS_PTS_Session).HasColumnName("SYS_PTS_Session");
            this.Property(t => t.IP_Requisition).HasColumnName("IP_Requisition");
            this.Property(t => t.IP_RFQ).HasColumnName("IP_RFQ");
            this.Property(t => t.IP_Quotation).HasColumnName("IP_Quotation");
            this.Property(t => t.Sys_No_OPR_Del).HasColumnName("Sys_No_OPR_Del");
            this.Property(t => t.Sys_No_OPR_edit).HasColumnName("Sys_No_OPR_edit");
            this.Property(t => t.DM_Document).HasColumnName("DM_Document");
            this.Property(t => t.ACP_AutoClientPatching).HasColumnName("ACP_AutoClientPatching");
            this.Property(t => t.ACP_Path).HasColumnName("ACP_Path");
            this.Property(t => t.ACP_PatchFile).HasColumnName("ACP_PatchFile");
            this.Property(t => t.ACP_Build).HasColumnName("ACP_Build");
            this.Property(t => t.Sys_IP_SavePrice).HasColumnName("Sys_IP_SavePrice");
            this.Property(t => t.UseCurrencyAcctHeader).HasColumnName("UseCurrencyAcctHeader");
            this.Property(t => t.SYS_RoutineOverheadPerc).HasColumnName("SYS_RoutineOverheadPerc");
            this.Property(t => t.sys_ShowCustReportFormatsOnly).HasColumnName("sys_ShowCustReportFormatsOnly");
            this.Property(t => t.sys_ShowHospitalDueInBill).HasColumnName("sys_ShowHospitalDueInBill");
            this.Property(t => t.SYS_WFID).HasColumnName("SYS_WFID");
            this.Property(t => t.SYS_NotiID).HasColumnName("SYS_NotiID");
            this.Property(t => t.SYS_WF_MaximizeConsole).HasColumnName("SYS_WF_MaximizeConsole");
            this.Property(t => t.SYS_WF_MaximizeHistory).HasColumnName("SYS_WF_MaximizeHistory");
            this.Property(t => t.SYS_WF_NotiPreview).HasColumnName("SYS_WF_NotiPreview");
            this.Property(t => t.SYS_WF_WorkflowPreview).HasColumnName("SYS_WF_WorkflowPreview");
            this.Property(t => t.IP_GlobalPhysicalStart).HasColumnName("IP_GlobalPhysicalStart");
            this.Property(t => t.SYS_OE_FRS_NoConsultant).HasColumnName("SYS_OE_FRS_NoConsultant");
            this.Property(t => t.SYS_PT_RepeatProcedures).HasColumnName("SYS_PT_RepeatProcedures");
            this.Property(t => t.SA_RFQ).HasColumnName("SA_RFQ");
            this.Property(t => t.SA_Quotation).HasColumnName("SA_Quotation");
            this.Property(t => t.SA_Order).HasColumnName("SA_Order");
            this.Property(t => t.WF_WorkflowType).HasColumnName("WF_WorkflowType");
            this.Property(t => t.COM_contact).HasColumnName("COM_contact");
            this.Property(t => t.UDF_DefineEnabled).HasColumnName("UDF_DefineEnabled");
            this.Property(t => t.IP_CustomerInfo).HasColumnName("IP_CustomerInfo");
            this.Property(t => t.IP_VendorInfo).HasColumnName("IP_VendorInfo");
            this.Property(t => t.IP_itemOntheFly).HasColumnName("IP_itemOntheFly");
            this.Property(t => t.UF_MaximizeConsole).HasColumnName("UF_MaximizeConsole");
            this.Property(t => t.UF_FormType).HasColumnName("UF_FormType");
            this.Property(t => t.UF_Form).HasColumnName("UF_Form");
            this.Property(t => t.UDF_Page).HasColumnName("UDF_Page");
            this.Property(t => t.SYS_VisaRequired).HasColumnName("SYS_VisaRequired");
            this.Property(t => t.SYS_BL_PromptForDepartment).HasColumnName("SYS_BL_PromptForDepartment");
            this.Property(t => t.SYS_Patient_Duplicate_First).HasColumnName("SYS_Patient_Duplicate_First");
            this.Property(t => t.SYS_Patient_Duplicate_Last).HasColumnName("SYS_Patient_Duplicate_Last");
            this.Property(t => t.SYS_Patient_Duplicate_Father).HasColumnName("SYS_Patient_Duplicate_Father");
            this.Property(t => t.SYS_Patient_Duplicate_Mother).HasColumnName("SYS_Patient_Duplicate_Mother");
            this.Property(t => t.SYS_Patient_Duplicate_AFirst).HasColumnName("SYS_Patient_Duplicate_AFirst");
            this.Property(t => t.SYS_Patient_Duplicate_ALast).HasColumnName("SYS_Patient_Duplicate_ALast");
            this.Property(t => t.SYS_Patient_Duplicate_AFather).HasColumnName("SYS_Patient_Duplicate_AFather");
            this.Property(t => t.SYS_Patient_Duplicate_AMother).HasColumnName("SYS_Patient_Duplicate_AMother");
            this.Property(t => t.SYS_Patient_Duplicate_Mobile).HasColumnName("SYS_Patient_Duplicate_Mobile");
            this.Property(t => t.SYS_Patient_Duplicate_HomePhone).HasColumnName("SYS_Patient_Duplicate_HomePhone");
            this.Property(t => t.SYS_Patient_Duplicate_MinMatches).HasColumnName("SYS_Patient_Duplicate_MinMatches");
            this.Property(t => t.SYS_PA_ShowBatch).HasColumnName("SYS_PA_ShowBatch");
            this.Property(t => t.SYS_Debug).HasColumnName("SYS_Debug");
            this.Property(t => t.SYS_LOCK_PHYS_IN_TRTCARD).HasColumnName("SYS_LOCK_PHYS_IN_TRTCARD");
            this.Property(t => t.SM_Opportunity).HasColumnName("SM_Opportunity");
            this.Property(t => t.ACT_TASK).HasColumnName("ACT_TASK");
            this.Property(t => t.DC_NewPlanForEveryPhys).HasColumnName("DC_NewPlanForEveryPhys");
            this.Property(t => t.GL_ProtectBatchBalance).HasColumnName("GL_ProtectBatchBalance");
            this.Property(t => t.SYS_Salesman).HasColumnName("SYS_Salesman");
            this.Property(t => t.SYS_Enable_Bill_CreditNote).HasColumnName("SYS_Enable_Bill_CreditNote");
            this.Property(t => t.SYS_PH_ShowItemCostPlate).HasColumnName("SYS_PH_ShowItemCostPlate");
            this.Property(t => t.DC_HideClincicalNote).HasColumnName("DC_HideClincicalNote");
            this.Property(t => t.DC_HideToothNote).HasColumnName("DC_HideToothNote");
            this.Property(t => t.DC_HideProcedureNote).HasColumnName("DC_HideProcedureNote");
            this.Property(t => t.DC_SeperateNotes_DC_TRT).HasColumnName("DC_SeperateNotes_DC_TRT");
            this.Property(t => t.TRT_ShowPRNoteByDef).HasColumnName("TRT_ShowPRNoteByDef");
            this.Property(t => t.DC_HideDx).HasColumnName("DC_HideDx");
            this.Property(t => t.SYS_DeliveryNote).HasColumnName("SYS_DeliveryNote");
            this.Property(t => t.SYS_IP_UID2).HasColumnName("SYS_IP_UID2");
            this.Property(t => t.SM_Pricing).HasColumnName("SM_Pricing");
            this.Property(t => t.SM_Overhead).HasColumnName("SM_Overhead");
            this.Property(t => t.SYS_Item_ID2).HasColumnName("SYS_Item_ID2");
            this.Property(t => t.PIM_DOMAIN).HasColumnName("PIM_DOMAIN");
            this.Property(t => t.PIM_INFO).HasColumnName("PIM_INFO");
            this.Property(t => t.SYS_NoteList_Rename).HasColumnName("SYS_NoteList_Rename");
            this.Property(t => t.BL_DailyCeiling).HasColumnName("BL_DailyCeiling");
            this.Property(t => t.SM_CUSTID_Edit).HasColumnName("SM_CUSTID_Edit");
            this.Property(t => t.SM_CUSTID_IncType).HasColumnName("SM_CUSTID_IncType");
            this.Property(t => t.SYS_MedicalRecord2).HasColumnName("SYS_MedicalRecord2");
            this.Property(t => t.IP_AvgCostStartDate).HasColumnName("IP_AvgCostStartDate");
            this.Property(t => t.SM_NewDocRef_Mode).HasColumnName("SM_NewDocRef_Mode");
            this.Property(t => t.PER_EnablePerio).HasColumnName("PER_EnablePerio");
            this.Property(t => t.PER_Exam).HasColumnName("PER_Exam");
            this.Property(t => t.Per_ChartByDef).HasColumnName("Per_ChartByDef");
            this.Property(t => t.DC_Maximize).HasColumnName("DC_Maximize");
            this.Property(t => t.Per_ReDrawMode).HasColumnName("Per_ReDrawMode");
            this.Property(t => t.Per_DefSeq).HasColumnName("Per_DefSeq");
            this.Property(t => t.SD_Class).HasColumnName("SD_Class");
            this.Property(t => t.SD_Term).HasColumnName("SD_Term");
            this.Property(t => t.SD_Student).HasColumnName("SD_Student");
            this.Property(t => t.SD_Course).HasColumnName("SD_Course");
            this.Property(t => t.SD_teacher).HasColumnName("SD_teacher");
            this.Property(t => t.SD_Eval).HasColumnName("SD_Eval");
            this.Property(t => t.SD_Reg).HasColumnName("SD_Reg");
            this.Property(t => t.SYS_AuditTrail).HasColumnName("SYS_AuditTrail");
            this.Property(t => t.SYS_StudentEval).HasColumnName("SYS_StudentEval");
            this.Property(t => t.SYS_DefPhysAcct).HasColumnName("SYS_DefPhysAcct");
            this.Property(t => t.SYS_LogActions).HasColumnName("SYS_LogActions");
            this.Property(t => t.OP_AutoClose).HasColumnName("OP_AutoClose");
            this.Property(t => t.SYS_WEB).HasColumnName("SYS_WEB");
            this.Property(t => t.SYS_SM_PR_GenerateReference).HasColumnName("SYS_SM_PR_GenerateReference");
            this.Property(t => t.SYS_SM_PR_ReferencePrefix).HasColumnName("SYS_SM_PR_ReferencePrefix");
            this.Property(t => t.SM_Autocash).HasColumnName("SM_Autocash");
            this.Property(t => t.TP_ShowBalance).HasColumnName("TP_ShowBalance");
            this.Property(t => t.sys_CheckBatchDuplicateInVbatchdet).HasColumnName("sys_CheckBatchDuplicateInVbatchdet");
            this.Property(t => t.SYS_ShowChargesAcceptedScript).HasColumnName("SYS_ShowChargesAcceptedScript");
            this.Property(t => t.SYS_ChargesAcceptedScript).HasColumnName("SYS_ChargesAcceptedScript");
            this.Property(t => t.DL_GenerateOrderNB).HasColumnName("DL_GenerateOrderNB");
            this.Property(t => t.DL_OrderNB).HasColumnName("DL_OrderNB");
            this.Property(t => t.HR_Employee).HasColumnName("HR_Employee");
            this.Property(t => t.HR_CHILD).HasColumnName("HR_CHILD");
            this.Property(t => t.HR_Qual).HasColumnName("HR_Qual");
            this.Property(t => t.HR_Vacation).HasColumnName("HR_Vacation");
            this.Property(t => t.HR_Ticket).HasColumnName("HR_Ticket");
            this.Property(t => t.HR_Alw).HasColumnName("HR_Alw");
            this.Property(t => t.HR_Salary).HasColumnName("HR_Salary");
            this.Property(t => t.HR_Overtime).HasColumnName("HR_Overtime");
            this.Property(t => t.HR_Contract).HasColumnName("HR_Contract");
            this.Property(t => t.OE_WarnforNoCoverage).HasColumnName("OE_WarnforNoCoverage");
            this.Property(t => t.IP_ForceExpiryDateValue).HasColumnName("IP_ForceExpiryDateValue");
            this.Property(t => t.VCP_Compression).HasColumnName("VCP_Compression");
            this.Property(t => t.SYS_ImpactionIndex).HasColumnName("SYS_ImpactionIndex");
            this.Property(t => t.OE_ApplyDynamicPricingOnImport).HasColumnName("OE_ApplyDynamicPricingOnImport");
            this.Property(t => t.IA_Authorization).HasColumnName("IA_Authorization");
            this.Property(t => t.IA_EnableAuthorization).HasColumnName("IA_EnableAuthorization");
            this.Property(t => t.SYS_HideOppositeAccount).HasColumnName("SYS_HideOppositeAccount");
            this.Property(t => t.SYS_OE_CloseOnPrint).HasColumnName("SYS_OE_CloseOnPrint");
            this.Property(t => t.SYS_PY_CloseOnPrint).HasColumnName("SYS_PY_CloseOnPrint");
            this.Property(t => t.SYS_ShowAltItem).HasColumnName("SYS_ShowAltItem");
            this.Property(t => t.SYS_WF_MultNotiByDef).HasColumnName("SYS_WF_MultNotiByDef");
            this.Property(t => t.SYS_DC_MapProcedures).HasColumnName("SYS_DC_MapProcedures");
            this.Property(t => t.SYS_DC_ItemGroupDigits).HasColumnName("SYS_DC_ItemGroupDigits");
            this.Property(t => t.sys_Nssf_).HasColumnName("sys_Nssf#");
            this.Property(t => t.SYS_LB_DefRes).HasColumnName("SYS_LB_DefRes");
            this.Property(t => t.sys_RefreshPostEndDate).HasColumnName("sys_RefreshPostEndDate");
            this.Property(t => t.sys_AvgCost_PR).HasColumnName("sys_AvgCost_PR");
            this.Property(t => t.sys_ShowArchivedBillsInCM).HasColumnName("sys_ShowArchivedBillsInCM");
            this.Property(t => t.SYS_ADM_TSFPARTY).HasColumnName("SYS_ADM_TSFPARTY");
            this.Property(t => t.SYS_FAC_ID).HasColumnName("SYS_FAC_ID");
            this.Property(t => t.SYS_ADM_I).HasColumnName("SYS_ADM_I");
            this.Property(t => t.SYS_ADM_O).HasColumnName("SYS_ADM_O");
            this.Property(t => t.SYS_ADM_E).HasColumnName("SYS_ADM_E");
            this.Property(t => t.SYS_ADM_I_PREFIX).HasColumnName("SYS_ADM_I_PREFIX");
            this.Property(t => t.SYS_ADM_O_PREFIX).HasColumnName("SYS_ADM_O_PREFIX");
            this.Property(t => t.SYS_ADM_E_PREFIX).HasColumnName("SYS_ADM_E_PREFIX");
            this.Property(t => t.SD_GrdBreakup).HasColumnName("SD_GrdBreakup");
            this.Property(t => t.sys_ItemInfo_Purchasing).HasColumnName("sys_ItemInfo_Purchasing");
            this.Property(t => t.SYS_ADMIN_V2).HasColumnName("SYS_ADMIN_V2");
            this.Property(t => t.SYS_CaseNB_PROC_Active).HasColumnName("SYS_CaseNB_PROC_Active");
            this.Property(t => t.SYS_CaseNB_ReadOnly).HasColumnName("SYS_CaseNB_ReadOnly");
            this.Property(t => t.sys_InCaseNumPrefix).HasColumnName("sys_InCaseNumPrefix");
            this.Property(t => t.sys_OutCaseNumPrefix).HasColumnName("sys_OutCaseNumPrefix");
            this.Property(t => t.SYS_OR_ROOM).HasColumnName("SYS_OR_ROOM");
            this.Property(t => t.SYS_OR_Oper).HasColumnName("SYS_OR_Oper");
            this.Property(t => t.SYS_OR_OperStaff).HasColumnName("SYS_OR_OperStaff");
            this.Property(t => t.SYS_OR_OperEquip).HasColumnName("SYS_OR_OperEquip");

            // Relationships
            this.HasOptional(t => t.Acct)
                .WithMany(t => t.Sys)
                .HasForeignKey(d => d.Def_undercollacct_fordoctors);

        }
    }
}
